Tabela BloodPackage

Definicja tabeli BloodPackage

Name

BloodPackage

Code

BloodPackage

Comment

Dane szczególowe worka z donacja krwi


Lista kolumn tabeli BloodPackage

Name

Code

BloodPackageID

BloodPackageID

BloodAdmissionID

BloodAdmissionID

StockItemQuantityIndexID

StockItemQuantityIndexID

ResourceID

ResourceID

BloodGroupID

BloodGroupID

DonationNo

DonationNo

PhenotypeID

PhenotypeID

Quantity

Quantity

SubQuantity

SubQuantity

Volume

Volume

DonationDT

DonationDT

ValidityDate

ValidityDate

Division

Division


Kolumna BloodPackageID tabeli BloodPackage

Definicja kolumny BloodPackageID tabeli BloodPackage

Name

BloodPackageID

Code

BloodPackageID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna BloodAdmissionID tabeli BloodPackage

Definicja kolumny BloodAdmissionID tabeli BloodPackage

Name

BloodAdmissionID

Code

BloodAdmissionID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna StockItemQuantityIndexID tabeli BloodPackage

Definicja kolumny StockItemQuantityIndexID tabeli BloodPackage

Name

StockItemQuantityIndexID

Code

StockItemQuantityIndexID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ResourceID tabeli BloodPackage

Definicja kolumny ResourceID tabeli BloodPackage

Name

ResourceID

Code

ResourceID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna BloodGroupID tabeli BloodPackage

Definicja kolumny BloodGroupID tabeli BloodPackage

Name

BloodGroupID

Code

BloodGroupID

Data Type

NUMBER(10)

Mandatory

No

Comment

Grupa krwi


Kolumna DonationNo tabeli BloodPackage

Definicja kolumny DonationNo tabeli BloodPackage

Name

DonationNo

Code

DonationNo

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Numer donacji


Kolumna PhenotypeID tabeli BloodPackage

Definicja kolumny PhenotypeID tabeli BloodPackage

Name

PhenotypeID

Code

PhenotypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

Fenotyp


Kolumna Quantity tabeli BloodPackage

Definicja kolumny Quantity tabeli BloodPackage

Name

Quantity

Code

Quantity

Data Type

NUMBER(12,4)

Mandatory

No

Comment

Ilosc jednostek krwi


Kolumna SubQuantity tabeli BloodPackage

Definicja kolumny SubQuantity tabeli BloodPackage

Name

SubQuantity

Code

SubQuantity

Data Type

NUMBER(12,4)

Mandatory

No

Comment

Ilosc podjednostek krwi


Kolumna Volume tabeli BloodPackage

Definicja kolumny Volume tabeli BloodPackage

Name

Volume

Code

Volume

Data Type

NUMBER(12,4)

Mandatory

No

Comment

Objetosc preparatu


Kolumna DonationDT tabeli BloodPackage

Definicja kolumny DonationDT tabeli BloodPackage

Name

DonationDT

Code

DonationDT

Data Type

DATE

Mandatory

No

Comment

Data donacji


Kolumna ValidityDate tabeli BloodPackage

Definicja kolumny ValidityDate tabeli BloodPackage

Name

ValidityDate

Code

ValidityDate

Data Type

DATE

Mandatory

No

Comment

Data waznosci preparatu


Kolumna Division tabeli BloodPackage

Definicja kolumny Division tabeli BloodPackage

Name

Division

Code

Division

Data Type

VARCHAR2(50)

Mandatory

No

Comment

Podzial - parametr okresla donacje


Lista kluczy tabeli BloodPackage

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli BloodPackage

Definicja klucza Identifier_1 tabeli BloodPackage

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment